﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Contracts.aspx.vb" Inherits="str_Contracts" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .auto-style1 {
            width: 120px;
            text-align: right;
            vertical-align: top;
        }
        .auto-style2 {
            width: 120px;
            text-align: right;
            vertical-align: top;
        }
        .auto-style3 {
            width: 212px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <p>
        <table style="width:100%;">
            <tr>
                <td style="width: 20%">&nbsp;</td>
                <td style="width: 50%">
                    <asp:TextBox ID="txtsearch" runat="server" Width="100%"></asp:TextBox>
                </td>
                <td style="width: 30%">
                    <asp:Button ID="btnsearch" runat="server" Text="Search" />
                </td>
            </tr>
        </table>
    </p>
    <p>
        &nbsp;</p>
    <p>
         
    
          <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SQLDATALIST" Width="100%" PageSize="15" Font-Names="Tahoma" Font-Size="8pt" AutoGenerateColumns="False" DataKeyNames="c_key">
              <Columns>
                  <asp:CommandField ShowSelectButton="True" />
                  <asp:BoundField DataField="c_key" HeaderText="c_key" InsertVisible="False" ReadOnly="True" SortExpression="c_key" />
                  <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
                  <asp:BoundField DataField="LongDesription" HeaderText="LongDesription" SortExpression="LongDesription" />
                  <asp:BoundField DataField="Provider" HeaderText="Provider" SortExpression="Provider" />
                  <asp:BoundField DataField="DateUploaded" HeaderText="DateUploaded" SortExpression="DateUploaded" />
                  <asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" />
                  <asp:BoundField DataField="TimeStamp" HeaderText="TimeStamp" SortExpression="TimeStamp" />
                  <asp:BoundField DataField="Author" HeaderText="Author" SortExpression="Author" />
                  <asp:BoundField DataField="ImageKey" HeaderText="ImageKey" SortExpression="ImageKey" />
              </Columns>
              <FooterStyle BackColor="White" ForeColor="#000066" />
              <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
              <PagerSettings PageButtonCount="15" />
              <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Center" />
              <RowStyle ForeColor="#000066" />
              <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
              <SortedAscendingCellStyle BackColor="#F1F1F1" />
              <SortedAscendingHeaderStyle BackColor="#007DBB" />
              <SortedDescendingCellStyle BackColor="#CAC9C9" />
              <SortedDescendingHeaderStyle BackColor="#00547E" />
          </asp:GridView>
    </p>
         
    
          <hr />
    <table style="width:100%;">
        <tr>
            <td >
                &nbsp;</td>
            <td colspan="2">
                <asp:Image ID="Image1" runat="server" Height="250px" Width="100%" />
            </td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style1">
                &nbsp;</td>
            <td class="auto-style3">
                <asp:FileUpload ID="FileUpload1" runat="server" Width="238px" />
            </td>
            <td class="auto-style2">&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td class="auto-style1">Description&nbsp;</td>
            <td class="auto-style3">
                <asp:TextBox ID="txtdesc" runat="server" CssClass="textbox" Width="250px"></asp:TextBox>
            </td>
            <td class="auto-style2">
                Provider&nbsp;</td>
            <td>
                <asp:TextBox ID="txtprovider" runat="server" CssClass="textbox" Width="250px"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td class="auto-style1">&nbsp;</td>
            <td class="auto-style3">
                &nbsp;</td>
            <td class="auto-style2">
                Date Uploaded&nbsp;</td>
            <td>
                <asp:TextBox ID="txtdateuploaded" runat="server" CssClass="textbox" Width="250px"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td class="auto-style1">Long Description&nbsp;</td>
            <td class="auto-style3">
                <asp:TextBox ID="txtlongdesc" runat="server" Height="90px" TextMode="MultiLine" Width="250px" CssClass="multitextbox"></asp:TextBox>
            </td>
            <td class="auto-style2">
                Comments&nbsp;</td>
            <td>
                <asp:TextBox ID="txtcomments" runat="server" Height="90px" TextMode="MultiLine" Width="250px" CssClass="multitextbox"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td class="auto-style1">&nbsp;</td>
            <td class="auto-style3">
                <asp:Button ID="Button1" runat="server" Text="Save" Width="104px" CssClass="button" />
                <asp:Button ID="Button2" runat="server" Text="Cancel" Width="104px" CssClass="button" />
            </td>
            <td class="auto-style2">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    </p>
    <p>
         
    
          &nbsp;</p>
    <p>
         
    
          &nbsp;</p>
    <p>
         
    
          <br />
    </p>
    <asp:SqlDataSource ID="SQLDATALIST" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" DeleteCommand="DELETE FROM [contract_items] WHERE [c_key] = @c_key" InsertCommand="INSERT INTO [contract_items] ([Description], [LongDesription], [Provider], [DateUploaded], [Comments], [TimeStamp], [Author], [ImageKey]) VALUES (@Description, @LongDesription, @Provider, @DateUploaded, @Comments, @TimeStamp, @Author, @ImageKey)" SelectCommand="SELECT * FROM [contract_items]" UpdateCommand="UPDATE [contract_items] SET [Description] = @Description, [LongDesription] = @LongDesription, [Provider] = @Provider, [DateUploaded] = @DateUploaded, [Comments] = @Comments, [TimeStamp] = @TimeStamp, [Author] = @Author, [ImageKey] = @ImageKey WHERE [c_key] = @c_key">
        <DeleteParameters>
            <asp:Parameter Name="c_key" Type="Int64" />
        </DeleteParameters>
        <InsertParameters>
            <asp:ControlParameter ControlID="txtdesc" Name="Description" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="txtlongdesc" Name="LongDesription" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="txtprovider" Name="Provider" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="txtdateuploaded" Name="DateUploaded" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="txtcomments" Name="Comments" PropertyName="Text" Type="String" />
            <asp:SessionParameter Name="TimeStamp" SessionField="timestamp" Type="String" />
            <asp:SessionParameter Name="Author" SessionField="Author" Type="String" />
            <asp:SessionParameter Name="ImageKey" SessionField="imagekey" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="Description" Type="String" />
            <asp:Parameter Name="LongDesription" Type="String" />
            <asp:Parameter Name="Provider" Type="String" />
            <asp:Parameter Name="DateUploaded" Type="String" />
            <asp:Parameter Name="Comments" Type="String" />
            <asp:Parameter Name="TimeStamp" Type="String" />
            <asp:Parameter Name="Author" Type="String" />
            <asp:Parameter Name="ImageKey" Type="String" />
            <asp:Parameter Name="c_key" Type="Int64" />
        </UpdateParameters>
    </asp:SqlDataSource>
</asp:Content>

